﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$UserLoginDBConnection$" formatter="bizobj of Company">
	<Sql>
		SELECT companyId as id, t.name
		FROM 
		CompanyBasicSettings c
		LEFT OUTER JOIN ObjectTreeCounts as t on t.objectId = c.companyId
		WHERE domainNames like '%' + @domainName + '%'
	</Sql>
	<Param name="domainName" type="VarChar"/>

</AdoNetDataAccess>